package DAO;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Date;

import Model.Paciente;
import Utils.Conexao;

import com.mysql.jdbc.CallableStatement;

public class RelatoriosDAO {
	public static ResultSet relatorioCheckup(java.sql.Date data_inicio, java.sql.Date data_fim) throws SQLException
	{
		Connection con = Conexao.getConection();		
		String mysqlCall = "call spc_relatorio_checkup(?, ?)";
		CallableStatement call = (CallableStatement) con.prepareCall(mysqlCall);
		call.setDate(1, data_inicio);
		call.setDate(2, data_fim);
		ResultSet res = call.executeQuery();		
		
		call.close();
		con.close();
		
		return res;
	}
}
